package org.yxj.lib_downfile.db;

/**
 *
 * 下载记录表
 *
 * @author on 2022/8/25
 */
public class DownFileTable {

    /**
     * 表名
     */
    public static final String table  =  "downFileTable";

    /**
     * 列名
     * 文件下载路径
     */
    public static final String fileUrl  =  "fileUrl";
    /**
     * 列名
     * 明见名字
     */
    public static final String fileName  =  "fileName";
    /**
     * 列名
     * 文件路径
     */
    public static final String filePath  =  "filePath";
    /**
     * 列名
     * 文件长度
     */
    public static final String fileTotalLength  =  "fileTotalLength";
    /**
     * 列名
     * 当前下载进度
     */
    public static final String currentProgress  =  "currentProgress";


    /**
     * 创建表
     */
    public static final String sql = "create table "+table+" (_id integer PRIMARY KEY AUTOINCREMENT,"
            + fileName +" varchar,"
            + filePath +" varchar,"
            + fileUrl+ " varchar,"
            + fileTotalLength +" integer,"
            + currentProgress +" integer)";
}
